WAREHOUSE BUILDER COURSE CONTENT
Warehouse Builder
Setting Up and Starting Warehouse Builder
- Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup
- Describe Oracle Warehouse Builder program group components
- Log in to the Design Center
- Create a design repository and users
- Open a project and navigate the user interface
|
| Introducing OWB 10g R2 Architecture and Configuration
| - Discuss various design and run-time configurations
- Describe the Warehouse Builder repository architecture, users, and owners
- Describe the OWB repository architecture, users, and owners
- Explain the benefits of warehouse staging areas
- Describe the course data sources and targets
- Import metadata using tcl scripts
| |
- Define and create source modules
- Specify source data from flat files
- Specify source data from relational database tables
- Import source object metadata into the source modules
| |
| Ensuring Data Quality Using Data Profiling
| - Create a data profile
- Profile the data
- View profile results
- Analyze profile results
| |
| Defining Staging Metadata and Mapping Tables
| - Create a target module
- Add a staging table to a staging area warehouse module
- Define mappings between source objects and staging table columns
| |
|
| Deriving Data Rules and Running Correction Mappings
| - Derive data rules
- Create a correction
- Run the generated correction mappings
| |
| Defining a Relational Dimensional Model
| - Define dimensions and cubes
- Navigate the Data Object Editor
- Define ETL mappings to load the dimensions and cubes
| |
| Handling Slowly Changing Dimensions
| - Explain how OWB handles a slowly changing dimension
- Define a type 2 slowly changing dimension
- Use the type 2 policy dialog box
| |
- Navigate the process flow editor
- Create process flow definitions
- Define a schedule
- Use process flow activity templates
- Use process flow activities
| |
| Deploying, Loading, and Viewing Data
| - Use the Control Center Manager
- Load data into tables
- Use the Dependency Manager to manage metadata
| |
| Business Intelligence Integration
| - Define Oracle Discoverer structures
- Derive Oracle Discoverer structures
- Define cross-tab and graph presentation templates
| | | 
